Internal Sales

OBJECTIVE

The Internal Sales function is used to transfer inventory items to a project or from a company to another company, while maintaining a profit margin.

You can also generate a cost for returning items from the project to inventory.

PREREQUISITEs

Summary

Create an internal sale
- Add an item from a kit

Steps

maestro* > Purchasing >Inventory > Processing > Internal Sales

Create an internal sale

You can import internal sales transactions from an Excel file. You can also complete the grid by searching for items by reservation number.

Enter the required information in the Detail tab:

Fields followed by the * character are mandatory fields.

Field

Description

Date*

Date on which the transfer transaction is posted.

NOTE: This date must be within a valid and open period.

Reference

Reference number for the transaction.

Work Order

Work order number associated with the transaction.

NOTE: The system only lets you select an existing work order if the Work Orders module is installed.

The currency is identified by the system. This value cannot be changed. For all new transactions, the currency displayed is the one configured in the settings for the current company.

Default Values section:

Field

Description

Company

Default company name to which the items are transferred.

NOTE: The cost allocated for this company is for items plus the profit margin for the current company.

The companies are displayed based on access defined in Security Management.

Available in multidimensional mode only.

Project*

Default project to which the transfer costs will be allocated.

NOTE: The list of available projects is displayed based on Security Management.

Activity*

Activity of the project to which the line amount is transferred.

Group*

Group of expenses to be allocated.

Site

Site for the items.

Container

Text field that identifies the container.

NOTE: The Advanced Material Destination Entry function must be enabled in Configuration.

Breakdown section:

The Entry of items by bar code icon is used to enter inventory codes using a bar code reader. For information on how this option functions, refer to the How to document on Entering Items Using Bar Codes.

Field

Description

Company

Name of the company to which the items are transferred.

NOTE: The cost allocated for this company is for items plus the profit margin for the current company.

The companies are displayed based on access defined in Security Management.

Available in multidimensional mode only.

#-Project*

Project to which the transfer costs will be allocated.

NOTE: The list of available projects is displayed based on Security Management.

Activity*

Activity of the project to which the line amount is transferred.

Group*

Group of expenses to be allocated.

Inventory Code

Inventory code from Catalogue Management.

If the item is a kit, see section Add item from a kit.

NOTE: Only inactive items and kits are not displayed.

Description

Description of the item.

Unit

Conversion unit.

NOTE: The unit varies based on the factor entered in the item in the Catalogue Management option.

Site

Site on which the item is located.

Location

Actual location of the item in the system.

NOTE: To determine the source of the location, refer to help on Reading Locations for Inventory Items.

Characteristic

Item characteristic.

Identification

Item identification.

Reservation No

Reservation number.

NOTE: This number can be entered manually by the user.

Container

Text field that identifies the container.

NOTE: The Advanced Material Destination Entry function must be enabled in Configuration.

Case

Text field that identifies the case.

NOTE: The Advanced Material Destination Entry function must be enabled in Configuration.

Box

Text field that identifies the box.

NOTE: The Advanced Material Destination Entry function must be enabled in Configuration.

Quantity*

Quantity to be transferred.

NOTE: A negative quantity reverses the transaction; from the project to inventory.

Inv. Unit

Inventory unit associated with the item in Catalogue Management.

Unit Price

Average cost of the inventory item.

Supplier U.P.

Converted unit price based on the supplier's conversion factor in Catalogue Management.

Sale U.P.*

Selling unit price.

NOTE: You can automatically display the desired profit rate by completing the Internal Profit Rate and/or Internal Return Rate fields in Catalogue Management.

Amount*

Amount to be transferred.

NOTE: If a quantity and unit price are entered, the system performs the calculation automatically.

Tax 1

Tax code to be applied.

Tax 2

Tax code to be applied.

Currency

Displays the currency associated with the company.

NOTE: Available in multidimensional mode only.

Field	Description
Date*	Date on which the transfer transaction is posted. NOTE: This date must be within a valid and open period.
Reference	Reference number for the transaction.
Work Order	Work order number associated with the transaction. NOTE: The system only lets you select an existing work order if the Work Orders module is installed.

Field	Description
Company	Default company name to which the items are transferred. NOTE: The cost allocated for this company is for items plus the profit margin for the current company. The companies are displayed based on access defined in Security Management. Available in multidimensional mode only.
Project*	Default project to which the transfer costs will be allocated. NOTE: The list of available projects is displayed based on Security Management.
Activity*	Activity of the project to which the line amount is transferred.
Group*	Group of expenses to be allocated.
Site	Site for the items.
Container	Text field that identifies the container. NOTE: The Advanced Material Destination Entry function must be enabled in Configuration.

Field	Description
Company	Name of the company to which the items are transferred. NOTE: The cost allocated for this company is for items plus the profit margin for the current company. The companies are displayed based on access defined in Security Management. Available in multidimensional mode only.
#-Project*	Project to which the transfer costs will be allocated. NOTE: The list of available projects is displayed based on Security Management.
Activity*	Activity of the project to which the line amount is transferred.
Group*	Group of expenses to be allocated.
Inventory Code	Inventory code from Catalogue Management. If the item is a kit, see section Add item from a kit. NOTE: Only inactive items and kits are not displayed.
Description	Description of the item.
Unit	Conversion unit. NOTE: The unit varies based on the factor entered in the item in the Catalogue Management option.
Site	Site on which the item is located.
Location	Actual location of the item in the system. NOTE: To determine the source of the location, refer to help on Reading Locations for Inventory Items.
Characteristic	Item characteristic.
Identification	Item identification.
Reservation No	Reservation number. NOTE: This number can be entered manually by the user.
Container	Text field that identifies the container. NOTE: The Advanced Material Destination Entry function must be enabled in Configuration.
Case	Text field that identifies the case. NOTE: The Advanced Material Destination Entry function must be enabled in Configuration.
Box	Text field that identifies the box. NOTE: The Advanced Material Destination Entry function must be enabled in Configuration.
Quantity*	Quantity to be transferred. NOTE: A negative quantity reverses the transaction; from the project to inventory.
Inv. Unit	Inventory unit associated with the item in Catalogue Management.
Unit Price	Average cost of the inventory item.
Supplier U.P.	Converted unit price based on the supplier's conversion factor in Catalogue Management.
Sale U.P.*	Selling unit price. NOTE: You can automatically display the desired profit rate by completing the Internal Profit Rate and/or Internal Return Rate fields in Catalogue Management.
Amount*	Amount to be transferred. NOTE: If a quantity and unit price are entered, the system performs the calculation automatically.
Tax 1	Tax code to be applied.
Tax 2	Tax code to be applied.
Currency	Displays the currency associated with the company. NOTE: Available in multidimensional mode only.

Click Save.
Click Transfer.

You can transfer several transactions at a time by clicking the Transaction Transfer icon on the main menu.

Add item from a kit

This feature applies to items whose Status corresponds to Kit in the Catalogue Management option.

In the Breakdown grid, enter the kit's inventory code in the column or click on the icon to select a kit through the Select a record window. The Component Selection window opens.
Enter the amount of kits (Quantity) needed in the transfer.
Check the kit items to include in the transfer.
Click on Select.

All chosen kit items will automatically be added to the transfer.
Save the transfer.